** Generate tables in "Intergenerational Effects of the EITC: The Case
** of Grandparents," National Tax Journal.

** Sara LaLumia
*******************************************************************************



*******************************************************************************
*******************************************************************************
** Table 1. Summary Statistics, Old-Generation Grandparents and 
** Middle-Generation Parents

** Sample = No mid-gen parent has any college education

use OrganizedOldGenData

** Table 1, Column 1: In financial regressions
table MissingDebtInfo if NoParsWithCollege==1  & EITC_v3~=.
table MissingDebtInfo if NoParsWithCollege==1  & EITC_v3~=. [pweight=wpfinwgt], statistic(mean tage Female Married White)
table MissingDebtInfo if NoParsWithCollege==1  & EITC_v3~=. [pweight=wpfinwgt], statistic(mean HSGrad SomeCollege CollegeGrad)

** Table 1, Column 2: In health regressions
table MissingHealthInfo if NoParsWithCollege==1  & EITC_v3~=.
table MissingHealthInfo if NoParsWithCollege==1  & EITC_v3~=. [pweight=wpfinwgt], statistic(mean tage Female Married White)
table MissingHealthInfo if NoParsWithCollege==1  & EITC_v3~=. [pweight=wpfinwgt], statistic(mean HSGrad SomeCollege CollegeGrad)

** Table 1, Column 3: Middle-generation parents
clear
use OrganizedParentLevelData

gen Any_GP = (N_DistinctGP>0)

table Any_GP if NoParsWithCollege==1
table Any_GP if (NoParsWithCollege==1  )  [pweight=wpfinwgt], statistic(mean tage Female MidGenPar_Married MidGenPar_White)
table Any_GP if (NoParsWithCollege==1 )  [pweight=wpfinwgt], statistic(mean MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_College)
clear


**********************************************************************************
**********************************************************************************
** Table 2: Effect of EITC Generosity on Formation of Three-Generation Households

use OrganizedParentLevelData

gen AnyGPinHH = (N_DistinctGP>0)

***********
** Panel A: Cross-Section. Dep Var = 1 if household has three generations

** Table 2A, Column 1: All parents of under-age-19 kids
areg AnyGPinHH r_MaxEITC_thou tage MidGenPar_White Female MidGenPar_Married MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr , absorb(tfipsst) cluster(UniquePersonID)

** Table 2A, Column 2: Single moms with less than a college degree
areg AnyGPinHH r_MaxEITC_thou tage MidGenPar_White MidGenPar_HSGrad MidGenPar_SomeCollege unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0), absorb(tfipsst) cluster(UniquePersonID)

** Table 2A, Column 3: Single moms with no college experience
areg AnyGPinHH r_MaxEITC_thou tage MidGenPar_White  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr if (Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0 & MidGenPar_SomeCollege==0), absorb(tfipsst) cluster(UniquePersonID)

***********
** Panel B: Entrance into Three-Gen Status
sort UniquePersonID swave
by UniquePersonID: gen AnyGPinHH_lead = AnyGPinHH[_n+1]

gen GP_exit = (AnyGPinHH==1 & AnyGPinHH_lead==0)
gen GP_entry = (AnyGPinHH==0 & AnyGPinHH_lead==1)

** Table 2B, Column 1: All parents of under-age-19 kids
reg GP_entry r_MaxEITC_thou tage MidGenPar_White Female MidGenPar_Married MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==0), absorb (tfipsst) 

** Table 2B, Column 2: Single moms with less than a college degree
reg GP_entry r_MaxEITC_thou tage MidGenPar_White  MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==0 & Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0), absorb (tfipsst) 

** Table 2B, Column 3: Single moms with no college experience at all
reg GP_entry r_MaxEITC_thou tage MidGenPar_White unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==0 & Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0 & MidGenPar_SomeCollege==0), absorb (tfipsst) 

***********
** Panel C: Exit from Three-Gen Status

** Table 2C, Column 1: All parents of under-age-19 kids
reg GP_exit r_MaxEITC_thou tage MidGenPar_White Female MidGenPar_Married MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==1), absorb (tfipsst) 

** Table 2C, Column 2: Single moms with less than a college degree
reg GP_exit r_MaxEITC_thou tage MidGenPar_White  MidGenPar_HSGrad MidGenPar_SomeCollege MidGenPar_CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==1 & Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0), absorb (tfipsst) 

** Table 2C, Column 3: Single moms with no college experience at all
reg GP_exit r_MaxEITC_thou tage MidGenPar_White unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr  if (swave==min_swave & AnyGPinHH==1 & Female==1 & MidGenPar_Married==0 & MidGenPar_CollegeGrad==0 & MidGenPar_SomeCollege==0), absorb (tfipsst) 

clear


**********************************************************************************
**********************************************************************************
** Table 3: EITC Effects on Grandparents' Well-Being

** Panels A and B: With SIPP Data

use OrganizedOldGenData

***************************************
** Table 3
** Column 1: Baseline
***************************************

areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)



***********************************
** Table 3
** Column 2: Simulated EITC
***********************************

areg AnyDebt EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_sim_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)


*******************************************************
** Table 3
** Column 3:  Non-refundable state EITCs set = 0
*******************************************************

areg AnyDebt ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth ref_EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)



***********************************************************************
*** Table 3, Column 4
** Using federal variation only
***********************************************************************

areg AnyDebt EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_FedOnly_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)


******************************************************************************
** Panel C: With CPS Data
clear
use OrganizedOldGenData_CPS


************
** Table 3C, Column 1: Baseline
areg ExcellentVeryGoodHealth EITC_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1  ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize ExcellentVeryGoodHealth if NoParsWithCollege==1 & EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017

areg PoorHealth EITC_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
 summarize PoorHealth if NoParsWithCollege==1  & EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017

 
************
** Table 3C, Column 2: Simulated EITC 
areg ExcellentVeryGoodHealth EITC_sim_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize ExcellentVeryGoodHealth if NoParsWithCollege==1  & EITC_sim_v3~=. & InHealthReg==1 & year>1995 & year<2017

areg PoorHealth EITC_sim_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize PoorHealth if NoParsWithCollege==1  & EITC_sim_v3~=. & InHealthReg==1 & year>1995 & year<2017


************
** Table 3C, Column 3: Nonrefundable EITC credits set = 0
areg ExcellentVeryGoodHealth ref_EITC_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize ExcellentVeryGoodHealth if NoParsWithCollege==1  & ref_EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017


areg PoorHealth ref_EITC_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize PoorHealth if NoParsWithCollege==1  & ref_EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017


************
** Table 3C, Column 4: Using federal variation only
areg ExcellentVeryGoodHealth EITC_FedOnly_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1  ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize ExcellentVeryGoodHealth if NoParsWithCollege==1 & EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017


areg PoorHealth EITC_FedOnly_v3 age AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.year i.N_PotentialDep if (NoParsWithCollege==1 ) & year>1995 & year<2017, absorb(statefip) cluster(statefip)
summarize PoorHealth if NoParsWithCollege==1  & EITC_v3~=. & InHealthReg==1 & year>1995 & year<2017

clear

********************************************************************************
********************************************************************************
** Table 4: Heterogeneity for Grandparents' Financial Outcomes

use OrganizedOldGenData

****************************************
** Table 4, Panel A: Dep Var = Any Debt
****************************************

** By Gender
areg AnyDebt EITC_v3 Male_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + Male_EITC_v3)=0


** By Marital Status
areg AnyDebt EITC_v3 Married_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + Married_EITC_v3)=0


*** By Age
areg AnyDebt EITC_v3 AgeGroup4_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + AgeGroup4_EITC_v3)=0


*** By Race
areg AnyDebt EITC_v3 White_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + White_EITC_v3)=0


** By Whether Middle Generation Includes a Single Mom
areg AnyDebt EITC_v3 AnySingleMom_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep  if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + AnySingleMom_EITC_v3)=0


*****************************************
** Table 4, Panel B: Dep Var = ln_r_Debt
*****************************************

** By Gender
areg ln_r_Debt EITC_v3 Male_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + Male_EITC_v3)=0


** By Marital Status
areg ln_r_Debt EITC_v3 Married_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + Married_EITC_v3)=0


*** By Age
areg ln_r_Debt EITC_v3 AgeGroup4_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + AgeGroup4_EITC_v3)=0


*** By Race
areg ln_r_Debt EITC_v3 White_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + White_EITC_v3)=0


** By Whether Middle Generation Includes a Single Mom
areg ln_r_Debt EITC_v3 AnySingleMom_EITC_v3 tage AgeSq Male Married White HSGrad SomeCollege CollegeGrad unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep  if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)
test (EITC_v3 + AnySingleMom_EITC_v3)=0


*******************************************************************************
*******************************************************************************
** Table 5: Alternative Samples

************
** Table 5
** Column 1: Youngest Generation Kids all Older than Five

areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & MinAge_PotentialDep>5), absorb(tfipsst) cluster(tfipsst)


***************
** Table 5
** Column 2: Dropping cases where oldest-gen GP could potentially be receiving own EITC on behalf of own EITC-elig kids

gen GPCouldClaimUsingOtherKid = (PotentialMidGenParent==1 & AnyParsPotentialDeps==0)

areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & GPCouldClaimUsingOtherKid==0), absorb(tfipsst) cluster(tfipsst)


****************
** Table 5
** Column 3: No Parent Is College Graduate


areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoCollegeGradPar==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)


************************************************************************
** Table 5
** Column 4: Middle generation includes single mom

areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0 & AnySingleMom==1), absorb(tfipsst) cluster(tfipsst)


********************************************************************************
********************************************************************************
** Table 6: Controlling for Potential Mechanisms


** Table 6, Panel A: Grandparent Employment

areg AnyDebt EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 Employed tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)


** Table 6, Panel B: Any Mid-Gen Parent Relies on Grandparent-Provided Childcare

areg AnyDebt EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingDebtInfo==0), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 AnyParsGetCCFromGP tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.N_PotentialDep if (NoParsWithCollege==1 & MissingHealthInfo==0), absorb(tfipsst) cluster(tfipsst)


clear

*******************************************************************************************
*******************************************************************************************
** Table 7: Falsification Test for Middle-Generation Empty-Nesters Living with Own Parents


use OrganizedEmptyNesterOldGenData


areg AnyDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingDebtInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg AnyCCDebt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingDebtInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Debt EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingDebtInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg AnyChecking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingDebtInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg ln_r_Checking EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingDebtInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg ExcellentVeryGoodHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingHealthInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)

areg PoorHealth EITC_v3 tage AgeSq Female Married White HSGrad SomeCollege CollegeGrad  unemp_rate r_MaxWelf state_rate_wages minwage gdp any_w_a_extended i.rhcalyr i.Dep_Control if (NoENsWithCollege==1 & MissingHealthInfo==0 & Dep_Control>0 & Dep_Control~=.), absorb(tfipsst) cluster(tfipsst)
